package mudbconnection;

import java.sql.Date;
import java.util.List;

import muobject.Questionnaire;

public interface DBQuestionnaires {
	
	public String getTestDate(String stno, String year, String month, int frequency);
	
	public String getAnswer(String stno, String year, String month, String testDate, String qno);
	
	public List getListAnswer(String stno, String year, String month, String qno);
	
	public boolean setQuestionnaire(Questionnaire questionnaire);
	
	public boolean updateQuestionnaire(Questionnaire questionnaire);

	public boolean deleteQuestionnaire(String stno, String year, String month, String qno, String testDate);
	
	public List getListAnswerByYearTestdateStno(String stno, String year, String testDate);
	
	public List getTestDateByYearStno(String stno, String year);
	
	public List getTestDateByYearMonthStno(String stno, String year, String month);
	
}
